SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwbincripcionesJines
AS
SELECT     Nombre AS Organizacion, Documento, AnioLectivo AS Año, EtapaInscripcion
FROM         dbo.vw_inscripcionesJIN
WHERE     (Documento IN
                          (SELECT DISTINCT documento
                            FROM          vw_inscripcionesJIN
                            GROUP BY documento
                            HAVING      COUNT(*) > 1)) AND (Documento <> 25851790)
GO
GRANT SELECT ON  [dbo].[vwbincripcionesJines] TO [Alumnos]
GO
